<?php

class Framework_DB_Table_GuestBook extends Framework_DB_Table_Common {

	public $tableName = 'GuestBook';
	
    public function __construct($db) {
   		
   		// Columns
   		$this->col = array(
	   		// Primary Key
	        'idGuestBook' => array(
	            'type'    => 'integer',
	            'require' => true
	        ),
	        
	        // Foreign Key, owner of the guestbook
	        'idOwner' => array(
	            'type'    => 'integer',
	            'require' => true
	        ),
	        
	        // Foreign Key, signer of guestbook
	        'idSiteUser' => array(
	            'type'    => 'integer',
	            'require' => true
	        ),
	        
	        'dateAdded' => array(
	        	'type'    => 'integer',
	            'require' => true
	        ),
	        
	        'message' => array(
	            'type'    => 'clob',
	            'require' => true 
	        ),

	        
	        
	    );
	    
	    $this->auto_inc_col = 'idGuestBook';
	    
	    // Indexes
	    $this->idx = array(
	    	'idGuestBook' =>  'primary',
	    	'idOwner' =>  'normal',
	    	'idSiteUser' =>  'normal'
	    );
   		
   		parent::__construct($db);
   }
	
	
}

?>